package cn.tedu.boot31.boot22.utils;

import com.alibaba.druid.pool.DruidDataSource;

import java.sql.Connection;
import java.sql.SQLException;

public class DBUtils {
    private static DruidDataSource ds;
    static {
        ds = new DruidDataSource();
        ds.setUrl("jdbc:mysql://localhost:3306/empdb" +
                "?characterEncoding=utf8" +
                "&serverTimezone=Asia/Shanghai");
        ds.setUsername("root");
        ds.setPassword("root");
        ds.setInitialSize(3);//设置初始链接数量
        ds.setMaxActive(5);//设置最大链接数量
    }

    public static Connection getConn() throws SQLException {

        Connection conn = ds.getConnection();
        System.out.println(conn);
        return conn;
    }
}
